2013-04-08 - 5910.200 - Rel Notes - Contracts - Release 022 #BIReleases2013

Release Notes:

‍5910.200 - OSA100 - Open Orders by Fiscal Year

‍Admin Info

Purpose
 Including Contract Information in OSA100 - Open Orders by FIscal Year
Release No
 022
Submitted
 04-08-2013
Submitted by
 Mallareddy D
Source/Destination Systems
 IT > BMS > Quality > Contracts to IT > BMS > Production > Contracts in SAP BO BI 4.0 Dev Environment
Release Sent To
 Mark Harris
Object(s) Created By
 Praveen Guntuka
Object(s) Tested By
 Praveen Guntuka

‍Report Name

OSA100 - Open Orders by Fiscal Year

‍BEx Query

ZMP_OOCON_Q003

‍NEC Crystal Reports Standards Check

1. OSA100 has been successfully checked against the NEC Crystal Reports Standards Checklist.
2. OSA100 NEC CR checklist has been sent to NEC and also attached here for reference:
OSA100 NEC CR Standard Check List.xlsx

Dynamic Group 1:

‍‍Test Conducted

Dynamic Grouping Parameter(1) and Group Name: Sales Org > Year > Period > Company > Customer > Order

‍Summary Level Check

‍Test Conducted

Group 1 : Sales Organization Name : 5th & Ocean Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 612
 612
 Pass
2
 Confirmed Quantity
 1,318,017
 1,318,017
 Pass
3
 Sales Org Currency
 12,362,633
 12,362,633.12
 Pass
4
 Corporate Currency
 12,362,633
 12,362,633.12
 Pass

Group 1 : Sales Organization Name : EMEA Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 9,131
 9,131
 Pass
2
 Confirmed Quantity
 1,849,144
 1,849,144
 Pass
3
 Sales Org Currency
 15,473,730
 15,473,652.97
 Pass
4
 Corporate Currency
 23,444,705
 23,444,676.76
 Pass
Note: For EMEA Sales, Sales Org Currency and Corporate Currency are not matching with BEx Query values. The difference is £77 and $28 respectively. Considered as successfully validated.

Group 2 : APAC Sales > 2012
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 3
 3
 Pass
2
 Confirmed Quantity
 283
 283
 Pass
3
 Sales Org Currency
 39,358
 39,357.30
 Pass
4
 Corporate Currency
 5,070
 5,069.83
 Pass

Group 3 : Australia Sales > 2013 > July 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 34
 34
 Pass
2
 Confirmed Quantity
 2,054
 2,054
 Pass
3
 Sales Org Currency
 42,733
 42,733.38
 Pass
4
 Corporate Currency
 44,544
 44,543.82
 Pass

Group 4 : Canada Sales > 2013 > April 2013 > 306 HIP HOP SK8 SHOP - 1007700
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 5
 5
 Pass
2
 Confirmed Quantity
 353
 353
 Pass
3
 Customer Currency
 6,375.78
 6,375.78
 Pass
4
 Sales Org Currency
 6,375.78
 6,375.78
 Pass
5
 Corporate Currency
 6,273.77
 6,273.77
 Pass

Group 5 : EMEA Sales > 2013 > April 2013 > 015 BOARDS & LIFESTYLE - 1012153 > 1271734
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Order Date
 10/22/12
 22/10/2012
 Pass
2
 First Ship
 4/9/13
 09/04/2013
 Pass
3
 Last Ship
 4/9/13
 09/04/2013
 Pass
4
 Cancel date
 5/9/13
 09/05/2013
 Pass
5
 No. of Orders
 -
 -
 Pass
6
 Confirmed Quantity
 30
 30
 Pass
7
 Customer Currency
 471.00
 471.00
 Pass
8
 Sales Org Currency
 397.92
 397.90
 Pass
9
 Corporate Currency
 602.83
 602.83
 Pass

Group 6 : EMEA Web Sales > 2013 > March 2013 > NEW ERA CAP CO LTD EURO - 1004352 > 1450655 >10255246
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Material No.
 10255246
 10255246
 Pass
2
 Material
 CAP CARRIER 6 BLACK
 CAP CARRIER 6 BLACK
 Pass
3
 Collection
 CAP CARRIER 6 BLACK
 CAP CARRIER 6 BLACK
 Pass
4
 Order Status
 O
 1
 Pass
5
 Confirmed Quantity
 1
 1
 Pass
6
 Unit Price
 19.10
 19.10
 Pass
7
 Customer Currency
 19.10
 19.10
 Pass
8
 Sales Org Currency
 16.14
 16.14
 Pass
9
 Corporate Currency
 24.45
 24.45
 Pass

‍Dynamic Group 2:

‍‍Test Conducted

Dynamic Grouping Parameter(2) and Group Name: Sales Org > Year > Product Group > Period > Order

Summary Level Check

‍Test Conducted

Group 1 : Sales Organization Name : United States Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 37,851
 37,851
 Pass
2
 Confirmed Quantity
 10,886,707
 10,886,707
 Pass
3
 Sales Org Currency
 111,237,350
 111,237,350.22
 Pass
4
 Corporate Currenc
 111,237,350
 111,237,350.22
 Pass

Group 1 : Sales Organization Name : EMEA Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 9,131
 9,131
 Pass
2
 Confirmed Quantity
 1,849,144
 1,849,144
 Pass
3
 Sales Org Currency
 15,473,730
 15,473,652.97
 Pass
4
 Corporate Currency
 23,444,705
 23,444,676.76
 Pass
Note: For EMEA Sales, Sales Org Currency and Corporate Currency are not matching with BEx Query values. The difference is £77 and $28 respectively. Considered as successfully validated.

Group 2 : NEC Korea Sales > 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 33
 33
 Pass
2
 Confirmed Quantity
 23,016
 23,016
 Pass
3
 Sales Org Currency
 441,228,344
 441,228,344.00
 Pass
4
 Corporate Currency
 397,106
 397,105.51
 Pass

Group 3 : Mexico Sales > 2013 > Headwear
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 140
 140
 Pass
2
 Confirmed Quantity
 361,950
 361,950
 Pass
3
 Sales Org Currency
 78,022,901
 78,022,901.08
 Pass
4
 Corporate Currency
 6,319,855
 6,319,854.99
 Pass

Group 4 : Latin America Sales > 2013 > Accessories > January 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 1
 1
 Pass
2
 Confirmed Quantity
 192
 192
 Pass
3
 Customer Currency
 1,881.60
 1,881.60
 Pass
4
 Sales Org Currency
 1,881.60
 1,881.60
 Pass
5
 Corporate Currency
 1,881.60
 1,881.60
 Pass

Group 5 : German Sales > 2013 > Point of Purchase > April 2013 > 1457380
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Order Date
 4/5/13
 05/04/2013
 Pass
2
 First Ship
 4/12/13
 12/04/2013
 Pass
3
 Last Ship
 4/12/13
 12/04/2013
 Pass
4
 Cancel date
 5/12/13
 12/05/2013
 Pass
5
 No. of Orders
 -
 -
 Pass
6
 Confirmed Quantity
 28
 28
 Pass
7
 Customer Currency
 0.00
 0.00
 Pass
8
 Sales Org Currency
 0.00
 0.00
 Pass
9
 Corporate Currency
 0.00
 0.00
 Pass

Group 6 : EMEA Web Sales > 2013 > Headwear > March 2013 > 1417209 > 10010244
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Material No.
 10010244
 10010244
 Pass
2
 Material
 UK ACPERF BOSRED GM
 UK ACPERF BOSRED GM
 Pass
3
 Collection
 AC PERFORMANCE
 AC PERFORMANCE
 Pass
4
 Order Status
 O
 1
 Pass
5
 Confirmed Quantity
 1
 1
 Pass
6
 Unit Price
 22.11
 22.11
 Pass
7
 Customer Currency
 22.11
 22.11
 Pass
8
 Sales Org Currency
 22.11
 22.11
 Pass
9
 Corporate Currency
 33.50
 33.50
 Pass

‍Dynamic Group 3:

Test Conducted

Dynamic Grouping Parameter(3) and Group Name: Sales Org > Year > Period > Product Group > Order

Summary Level Check

‍Test Conducted

Group 1 : Sales Organization Name : 5th & Ocean Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 612
 612
 Pass
2
 Confirmed Quantity
 1,318,017
 1,318,017
 Pass
3
 Sales Org Currency
 12,362,633
 12,362,633.12
 Pass
4
 Corporate Currency
 12,362,633
 12,362,633.12
 Pass

Group 1 : Sales Organization Name : EMEA Sales
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 9,131
 9,131
 Pass
2
 Confirmed Quantity
 1,849,144
 1,849,144
 Pass
3
 Sales Org Currency
 15,473,730
 15,473,652.97
 Pass
4
 Corporate Currency
 23,444,705
 23,444,676.76
 Pass
Note: For EMEA Sales, Sales Org Currency and Corporate Currency are not matching with BEx Query values. The difference is £77 and $28 respectively. Considered as successfully validated.

Group 2 : APAC Sales > 2012
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 3
 3
 Pass
2
 Confirmed Quantity
 283
 283
 Pass
3
 Sales Org Currency
 39,358
 39,357.60
 Pass
4
 Corporate Currency
 5,070
 5,069.83
 Pass

Group 3 : Australia Sales > 2013 > August 2013
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 45
 45
 Pass
2
 Confirmed Quantity
 4,856
 4,856
 Pass
3
 Sales Org Currency
 92,676
 92,676.39
 Pass
4
 Corporate Currency
 96,624
 96,624.40
 Pass

Group 4 : Canada Sales > 2013 > December 2013 > Headwear
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 No. of Orders
 6
 6
 Pass
2
 Confirmed Quantity
 1,695
 1,695
 Pass
3
 Customer Currency
 15,048.75
 15,048.75
 Pass
4
 Sales Org Currency
 15,048.75
 15,048.75
 Pass
5
 Corporate Currency
 14,807.98
 14,807.98
 Pass

Group 5 : German Sales > 2013 > March 2013 > Headwear > 1342158
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Order Date
 1/10/13
 10/01/2013
 Pass
2
 First Ship
 3/25/13
 25/03/2013
 Pass
3
 Last Ship
 3/25/13
 25/03/2013
 Pass
4
 Cancel date
 6/18/2013
 18/06/2013
 Pass
5
 No. of Orders
 -
 -
 Pass
6
 Confirmed Quantity
 30
 30
 Pass
7
 Customer Currency
 537.00
 537.00
 Pass
8
 Sales Org Currency
 537.00
 537.00
 Pass
9
 Corporate Currency
 687.31
 687.31
 Pass

Group 6 : Mexico Sales > 2013 > February 2013 > Headwear > 1371283 > 10622910
SNo
 Test Case
 Value in CR
 Value in BEx
 Pass/Fail Criteria
1
 Material No.
 10622910
 10622910
 Pass
2
 Material
 MX NFL ON FILED 5950 SAF49E GAME
 MX NFL ON FILED 5950 SAF49E GAME
 Pass
3
 Collection
 NFL On-Filed
 NFL On-Filed
 Pass
4
 Order Status
 O
 1
 Pass
5
 Confirmed Quantity
 5
 5
 Pass
6
 Unit Price
 45.86
 45.86
 Pass
7
 Customer Currency
 229.30
 229.30
 Pass
8
 Sales Org Currency
 229.30
 229.30
 Pass
9
 Corporate Currency
 18.57
 18.57
 Pass

‍Reference Document(Specification)

2013-03-15 - 5910.200 - Spec - Contract Reports